SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '5e6c6d53ee1be9ca4144c3307c82b97483152dfb2ac5715689d635a5632547d4' 
  AND token = 'wcfllOTbglAc0vBNlbq5UqiOJNxgigxcV120Ib0gGTY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00019

JSON explain

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