SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'de185c694e69e6d53e7bf8a1bb1b690e9602dbcf2469991ac419f02e1f7ef1d0' 
  AND token = '2v4RxGfoZk7neIN7uC5+Tgv2d58gSZ/dvSRDL2sx0fU=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00027

JSON explain

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