UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'GnaT1zS3VuOvxAAaH6X92FRcI0/RAkUymwtqig2DjOM='
WHERE
key_id = 'ebe8f7f4248100e29addf9913d9b4dd07d12f1b9a4a2f3545cbaea1a3d24169d'
AND (
token = 'GnaT1zS3VuOvxAAaH6X92FRcI0/RAkUymwtqig2DjOM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)