UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZpDQwZ34JcDqm43gnijw8/4fAF5uWVnKrqxWiH/zwFU='
WHERE
key_id = '9ca1e8878e41d3890773ec628897fc68a527b5177f04a5433c3264b48685e3e7'
AND (
token = 'ZpDQwZ34JcDqm43gnijw8/4fAF5uWVnKrqxWiH/zwFU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)