UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JCgiR2735FYcIVhHzJnUo0FfgVWcDslC/4J+cW6gouU='
WHERE
key_id = '768c64a1d22e0e5f8681dba535bfef9b53bf7df70b9fe0c9b3b275193b8ac5f5'
AND (
token = 'JCgiR2735FYcIVhHzJnUo0FfgVWcDslC/4J+cW6gouU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)