UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xqca6a/95BpkC7UXl/fuJi5bK727MdkcmedvvwBxebU='
WHERE
key_id = '9a8a4d89f43bca8a333570c8a9ba08cc5ac6620cfcee9d1733fd04639696ec97'
AND (
token = 'xqca6a/95BpkC7UXl/fuJi5bK727MdkcmedvvwBxebU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)