UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QCg6YjwGOio5uRciUqz4LbmqC32AhdqH5sCu5YsncZc='
WHERE
key_id = '2ca0f12d09d90e283963830ea1734fc78e7937dcf0309a130aa931c2e1fd2f1e'
AND (
token = 'QCg6YjwGOio5uRciUqz4LbmqC32AhdqH5sCu5YsncZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)