UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'esHHDUfiHgF81c17XVCXX7IR5kRAOeh1p/kh8YLDD4s='
WHERE
key_id = 'd799894bfd27ade5aa185fe81b5efd383731cb408d15fc030d586251b11311f2'
AND (
token = 'esHHDUfiHgF81c17XVCXX7IR5kRAOeh1p/kh8YLDD4s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)