UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1mS0GKYcefdhR7L1luQrG2PLv5hE0HHeEt4sN+uG+I8='
WHERE
key_id = '8a5b538d74caaba3fea25f561528d7d5614facd33cd78e4c70c0f819495b03d8'
AND (
token = '1mS0GKYcefdhR7L1luQrG2PLv5hE0HHeEt4sN+uG+I8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)