UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '9T928U/+KNP3M9N+ISftirM+QnosvFFQ6GtBEf8+ZFA=' 
WHERE 
  key_id = 'f85cacd1bb928d11cde8e6c9fc107899fa3186da5ad37447c5aed9e04f54e472' 
  AND (
    token = '9T928U/+KNP3M9N+ISftirM+QnosvFFQ6GtBEf8+ZFA=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00028