UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'ju1U3iZ/U1jzSxe4pl0XzrFw4u0ebN8P+8EK/QW+9VA=' 
WHERE 
  key_id = 'e4e1faa4bdad17361ab5666175a92717abd9bf56517f12b3e041b9252e3cb40c' 
  AND (
    token = 'ju1U3iZ/U1jzSxe4pl0XzrFw4u0ebN8P+8EK/QW+9VA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00038