UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DJUH/a7Wz60NV6D1UbsEJ+GDDqXVn30nHRofIDDjZPA='
WHERE
key_id = 'e07ec9649ea74c2e1c40932ab6fdad9a68f1dd494d8e2273aa94e198173bdda6'
AND (
token = 'DJUH/a7Wz60NV6D1UbsEJ+GDDqXVn30nHRofIDDjZPA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)