UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8x3PybpHt9cvKNWkO/3urXj69qgA83QuN//YspunwCY='
WHERE
key_id = 'd5c7fc8262f8a10a984275cd4b2d9478e891f9a442d3e9c4e9d9e47d753e21ae'
AND (
token = '8x3PybpHt9cvKNWkO/3urXj69qgA83QuN//YspunwCY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)