UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Br9eT/7y0liPGymDK0+mhtr01H+EIIoE5Kj5Lp6akNg='
WHERE
key_id = '0dfc0f9ea8adf0ca18080b0a54de2cdf5aeadadc1272c16d27f2c15e2c99fe96'
AND (
token = 'Br9eT/7y0liPGymDK0+mhtr01H+EIIoE5Kj5Lp6akNg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)