UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zRXKS0hv5kNlUo2XoOPol4xm8Lf+xb9GiomXAjb7KZ8='
WHERE
key_id = '1a92219e4f9fb51a9c890371151bbf3db6acc9090fff04e0e2eae4b8e682cf2b'
AND (
token = 'zRXKS0hv5kNlUo2XoOPol4xm8Lf+xb9GiomXAjb7KZ8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)