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