SELECT 
  1 
FROM 
  cscart_lock_keys 
WHERE 
  key_id = 'd21972e70c8694d8d3bf5d06ee8abc76af54ec8409ab7f21143352d3f15bd95d' 
  AND token = '31JcsqIOw3jgRRqWnqO8am7YvmqUTYUUWR6H6Xx5Ni8=' 
  AND expiry_at > UNIX_TIMESTAMP(NOW())

Query time 0.00029

JSON explain

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