UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g4WygJSaMbqsu9mGFlALX8VbpG3Qgm/+tEybXMIxLSg='
WHERE
key_id = '04c5a0848b5f442d7ece1f9f018a27a0e7e87960b63978c9a2783ee06cbf62b6'
AND (
token = 'g4WygJSaMbqsu9mGFlALX8VbpG3Qgm/+tEybXMIxLSg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)