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