SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = '54e5a61700c4ae86296d3c2760e5fdd37e3073206ea15afe86289c515949f7b1' 
  AND token = 'ehTMjgGjwDcU0Z8CXQe1HCTgzkEuC3y9Koy8O91rpuY=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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