UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'TqOtgGKD4tR3W8aLr76FOvwpj8RAuE4tzMzoNgPX9UU=' 
WHERE 
  key_id = '7756317dd7f127c1ffdd580624cde698858a732007e0fee9e8544701873d6cd5' 
  AND (
    token = 'TqOtgGKD4tR3W8aLr76FOvwpj8RAuE4tzMzoNgPX9UU=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00088