UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vp/ZNY5k/TIWpwe+LfvqldzgCh+iP9aA9OoCrj08pLA='
WHERE
key_id = 'ca8a959aa7770b283dc7c41343d01d4c1146aea0b9656887f26fcc67f16a06e9'
AND (
token = 'Vp/ZNY5k/TIWpwe+LfvqldzgCh+iP9aA9OoCrj08pLA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)