UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ySgsmHlLHTZsIWSnNN09sZqvJO5gHh61NHm8fs/cEwA='
WHERE
key_id = '604601e0b238961af01a34b1551c85b58a44da0c97f3095b509c60d50d2292f1'
AND (
token = 'ySgsmHlLHTZsIWSnNN09sZqvJO5gHh61NHm8fs/cEwA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)