UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PNk+T1H45bpwMjfKLO4hMnUn1UQThvpnfu9jfyugfn8='
WHERE
key_id = '72a89dd23c520babb6ae9d0aebffff737e9226a50465f67dc8f5c1f39c0bcf3e'
AND (
token = 'PNk+T1H45bpwMjfKLO4hMnUn1UQThvpnfu9jfyugfn8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)