UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+G35chnUKCvxmR+tScxbTD8KqLk4+H1EAZasGM0oZio='
WHERE
key_id = 'ac1113657e762bc07d2141a421682423346419c4dbcb1a1907b90c86a37bfbe7'
AND (
token = '+G35chnUKCvxmR+tScxbTD8KqLk4+H1EAZasGM0oZio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)