UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9MnG31ECH6+xEGZ/qHxCkbHmkpmoyg3dXVavHk4y8Vg='
WHERE
key_id = '0174e33d224ef443a27c8b9cc8b493126b05238444dfa7c8446e792729ae0ec0'
AND (
token = '9MnG31ECH6+xEGZ/qHxCkbHmkpmoyg3dXVavHk4y8Vg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)