SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5214a0de487afcb98a4d624ad69ffc27ebea20c0071b5988a80dad1c778f680f' 
  AND token = 'pAYcJIgg8+jM7sxu4/i1MHWLGoNGu2h3EbpyFqOOv7I=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00031

JSON explain

{
  "query_block": {
    "select_id": 1,
    "message": "no matching row in const table"
  }
}