UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tSL0KLm+fQYhXcTuOI+/l9x2OuAWYkYWt84iaRb54yk='
WHERE
key_id = '046cfab5d31b75c628a6589ee644ceddb4892a252f246153d92bcced41948be5'
AND (
token = 'tSL0KLm+fQYhXcTuOI+/l9x2OuAWYkYWt84iaRb54yk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)