SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'ae911b9688a33baab574bae2aa1fcc6c25adbc35ff0a5592566f60912124288d' 
  AND token = '8W4V6vGp1CTHlbJdMVStNIRD5u2vEFFcq+OpV6mNqV8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00024

JSON explain

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