SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'dd712c1d4be2f784d7a2ac031f5d0152465fd0955648d125d14fdb5c080c0493' 
  AND token = 'UCtYJvKGNpb8B4Bo/DdR1gzJWHolhzR04nDmu7ldikM=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00021

JSON explain

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