UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pgoXMYhtXgwI7A2gTJkbgVUl2Rz2WA8n8FhGLu4fzlE='
WHERE
key_id = '6f8cc98fd56ada71a250d6437f7899733b6abff1df8453ad6bd3af6c1cba30ea'
AND (
token = 'pgoXMYhtXgwI7A2gTJkbgVUl2Rz2WA8n8FhGLu4fzlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)