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