UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k0bk0HegaEg4VW8fS4Ag3Zfnnq7HxF7zok0KeZpQJVQ='
WHERE
key_id = '1ca0df44a7d3e5b715ede3247a91f57bba9576b18a001f08ea3a1625c5862c8e'
AND (
token = 'k0bk0HegaEg4VW8fS4Ag3Zfnnq7HxF7zok0KeZpQJVQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)