UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hBPfj8wmFSjyF/A5s293Vhge+j+EWNwI+BB8MYBhg90='
WHERE
key_id = 'f3474f99037b1b833c65a0c2a9a809d16261b81978c988ff9e395b05c22f2208'
AND (
token = 'hBPfj8wmFSjyF/A5s293Vhge+j+EWNwI+BB8MYBhg90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)