SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '6b86207f04bba53f00031800246fa45a0223833b14686ca22c3f80789b5fe944' 
  AND token = '+581WY6q/qpBqviie3rc3ePNJ/l3KbsAb55YSLWBLDk=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00018

JSON explain

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