UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C46dAlTmPmr1Q3Qhktr7sFGThFeAbhwj+b3D7f9t+Eo='
WHERE
key_id = 'fd42cf7c250ee71129ed4aae8458a851b1d557a0a4a4a37a2e043c50e0c30399'
AND (
token = 'C46dAlTmPmr1Q3Qhktr7sFGThFeAbhwj+b3D7f9t+Eo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)