UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'W8hW0Lms3X5LZ4jkAaAmyuP3dr4x7I/ELx4jPKcJmdk=' 
WHERE 
  key_id = '7bacf2f5cf5b9ca0ef6acaf2b6d7baf8b64968c1c93838783c34e8bf34cbd2a6' 
  AND (
    token = 'W8hW0Lms3X5LZ4jkAaAmyuP3dr4x7I/ELx4jPKcJmdk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00030