UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7XO+3N5UW3h1nz6+YbVPWrCPRuajydGKu2fIOduCi1o='
WHERE
key_id = 'cdc7528ee1adf479bdab4293ec7181807f931e81e2c97be70f6bddba54dfc020'
AND (
token = '7XO+3N5UW3h1nz6+YbVPWrCPRuajydGKu2fIOduCi1o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)