UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '3RL9xGuEDxcOoPjoJjkSEMwV7kaR0QOV4BVaRjN++kA='
WHERE
key_id = '10a2e188f35f8be66582574c244e1811677dc7055872ba45aff2de508a4b75e2'
AND (
token = '3RL9xGuEDxcOoPjoJjkSEMwV7kaR0QOV4BVaRjN++kA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)