UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdWFDFoj33MY0r4EO66xbR2Bh2b5PLv+1Dz0JqROKAw='
WHERE
key_id = 'f0e078ae418c7947d439018de8f1acf75d6c4c1288691798dc067b622c1b5f46'
AND (
token = 'XdWFDFoj33MY0r4EO66xbR2Bh2b5PLv+1Dz0JqROKAw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)