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