UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VP07EkCywMTYvlPmaX6efyP7vlH+fUpHoux/ZHX3uj4='
WHERE
key_id = 'd7d3b040152305505665ec564175b2e1e6e9ccf88b6b74f5c94d28ae37a05b69'
AND (
token = 'VP07EkCywMTYvlPmaX6efyP7vlH+fUpHoux/ZHX3uj4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)