UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HsPgvP2iq2kOXXASW59ZaG+2fzpiKS9EQiwUoZRoWdo='
WHERE
key_id = 'be511e1b35193e5e1594e40ea332ad28cc9cd2a2b28bf56652732cb60a70e255'
AND (
token = 'HsPgvP2iq2kOXXASW59ZaG+2fzpiKS9EQiwUoZRoWdo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)