UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r55ap4s3Z2YS8x3nbpmxNCPRmTxLZ1n83wvx07MTeSI='
WHERE
key_id = 'f094fc9066754daf75f248dfde1df8f4eb89b5ecdd64fb3285dd4c28a4776ce0'
AND (
token = 'r55ap4s3Z2YS8x3nbpmxNCPRmTxLZ1n83wvx07MTeSI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)