UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CUHGo5buPcQ0wxPdtOdLQlMX82wJJUunH9Wt3p70K7A='
WHERE
key_id = 'd500f74c49887c1f9f26b7cbccfde596c10412326c6c90f9ec908a1dfa501941'
AND (
token = 'CUHGo5buPcQ0wxPdtOdLQlMX82wJJUunH9Wt3p70K7A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)